Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1

R_1

Status

LAccountDataStatus

StatusID

 

 

R_2

R_2

Message

LAccountDataStatus

MessageID

 

 

R_5

R_5

AccountTemplate

LAccountDataStatus

AccountTemplateID

 

 

R_6

R_6

BillType

AccountTemplate

BillTypeID

 

 

R_8

R_8

ErrorHierarchy

AccountingErrors

ErrorHierarchyID

 

 

R_15

R_15

ICDRevision

ICD

ICDRevisionID

 

 

R_16

R_16

Event

LEventICD

EventID

 

 

R_17

R_17

ICD

LEventICD

ICDID

 

 

R_18

R_18

Patient

Episode

PatientID

 

 

R_20

R_20

Episode

Event

EpisodeID

 

 

R_21

R_21

Event

AccountData

EventID

 

 

R_22

R_22

DocumentType

AccountTemplate

DocumentTypeID

 

 

R_49

R_49

AddressType

Address

AddressTypeID

 

 

R_50

R_50

Patient

LPatientAddress

PatientID

 

 

R_51

R_51

Address

LPatientAddress

AddressID

 

 

R_52

R_52

Patient

LPatientInsurance

PatientID

 

 

R_53

R_53

Insurance

LPatientInsurance

InsuranceID

 

 

R_69

R_69

InstanceType

AccountData

InstanceTypeID

 

 

R_71

R_71

MessageType

Message

MessageTypeID

 

 

R_72

R_72

MessageProblem

Message

MessageProblemID

 

 

R_80

R_80

PatientType

Patient

PatientTypeID

 

 

R_88

R_88

PersonnelType

Event

PersonnelTypeID

 

 

R_90

R_90

AccountData

LAccountDataStatus

AccountDataID

 

 

R_91

R_91

ICDType

LEventICD

ICDTypeID

 

 

R_94

R_94

PersonnelType

Referral

PersonnelTypeID

 

 

R_166

R_166

AccountData

LAccountDataToothArea

AccountDataID

 

 

R_167

R_167

IssueReferral

LEventIssueReferral

IssueReferralID

 

 

R_168

R_168

Event

LEventIssueReferral

EventID

 

 

R_169

R_169

RescueService

Event

RescueServiceID

 

 

R_180

R_180

PersonnelType

Personnel

PersonnelTypeID

 

 

R_187

R_187

AccountData

AccountData

Acc_AccountDataID

 

 

R_285

R_285

Event

LAccountDataStatus

EventID

 

 

R_286

R_286

Episode

LAccountDataStatus

EpisodeID

 

 

R_290

R_290

ExtOrgUnitInfo

ExtSystemInfo

ExtOrgUnitInfoID

 

 

R_291

R_291

Episode

ExtSystemInfo

EpisodeID

 

 

R_292

R_292

Event

ExtSystemInfo

EventID

 

 

R_293

R_293

AccountData

ExtSystemInfo

AccountDataID

 

 

R_310

R_310

Contractor

Message

ContractorID

 

 

R_322

R_322

RescueTeam

LOrgUnitRescueTeam

RescueTeamID

 

 

R_323

R_323

OrgUnit

LOrgUnitRescueTeam

OrgUnitID

 

 

R_324

R_324

RescueTeam

RescueService

RescueTeamID

 

 

R_330

R_330

ExtAccountDataInfo

ExtSystemInfo

ExtAccountDataInfoID

 

 

R_350

R_350

Contractor

AccountTemplate

ContractorID

 

 

R_360

R_360

OrgUnit

RescueService

OrgUnitID

 

 

R_413

R_413

OrgUnit

LEventICD

OrgUnitID

 

 

R_490

R_490

ExtOrgUnitInfo

ExtSystemInfo

Ext_ExtOrgUnitInfoID

 

 

R_520

R_520

AccountData

Agreement

AccountDataID

 

 

R_525

R_525

AccountData

AccountDataDocument

AccountDataID

 

 

R_530

R_530

Message

FileBackupData

MessageID

 

 

R_531

R_531

MessageType

FileBackupData

MessageTypeID

 

 


2